package jwdt.xadmin.custom.bean;

import jwdt.xadmin.system.bean.FLMX;
import jwdt.xadmin.system.bean.TUser;

import com.ezerg.db.Jdb;
import com.ezerg.db.annotation.Column;
import com.ezerg.db.annotation.Table;

@Table(name="t_car_sq", keys={"id"}, comment="")
public class TCarsq implements java.io.Serializable {

	private static final long serialVersionUID = 1L; 


	@Column(value="id", comment="")
	private String id;
	
	@Column(value="cph", comment="")
	private String cph;
	
	@Column(value="sqsj", comment="")
	private String sqsj;
	
	@Column(value="ycr", comment="")
	private String ycr;
	
	@Column(value="ycbm", comment="")
	private String ycbm;
	
	@Column(value="yhsy", comment="")
	private Integer yhsy;

	@Column(value="kssj", comment="")
	private String kssj;

	@Column(value="jssj", comment="")
	private String jssj;
	
	@Column(value="sqr", comment="")
	private Integer sqr;
	
	@Column(value="lc", comment="")
	private String lc;
	
	@Column(value="bz", comment="")
	private String bz;
	
	@Column(value="status", comment="")
	private Integer status;

	public String getUserfullname() {
		TUser user = (TUser)Jdb.get().get(TUser.class, sqr);
		if(user == null) {
			return "";
		} else {
			return user.getFullname();
		}
	}
	
	public String getFmxmc() {
		if(this.status == 0)
			return "";
		FLMX d = (FLMX)Jdb.get().get(FLMX.class, this.status);
		if(d == null)
			return "";
		return d.getMxmc();
	}
	
	
	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getCph() {
		return cph;
	}

	public void setCph(String cph) {
		this.cph = cph;
	}

	public String getSqsj() {
		return sqsj;
	}

	public void setSqsj(String sqsj) {
		this.sqsj = sqsj;
	}

	public String getYcr() {
		return ycr;
	}

	public void setYcr(String ycr) {
		this.ycr = ycr;
	}

	public String getYcbm() {
		return ycbm;
	}

	public void setYcbm(String ycbm) {
		this.ycbm = ycbm;
	}

	public Integer getYhsy() {
		return yhsy;
	}

	public void setYhsy(Integer yhsy) {
		this.yhsy = yhsy;
	}

	public String getKssj() {
		return kssj;
	}

	public void setKssj(String kssj) {
		this.kssj = kssj;
	}

	public String getJssj() {
		return jssj;
	}

	public void setJssj(String jssj) {
		this.jssj = jssj;
	}

	public Integer getSqr() {
		return sqr;
	}

	public void setSqr(Integer sqr) {
		this.sqr = sqr;
	}

	public String getLc() {
		return lc;
	}

	public void setLc(String lc) {
		this.lc = lc;
	}

	public String getBz() {
		return bz;
	}

	public void setBz(String bz) {
		this.bz = bz;
	}

	public Integer getStatus() {
		return status;
	}

	public void setStatus(Integer status) {
		this.status = status;
	}

	public static long getSerialversionuid() {
		return serialVersionUID;
	}
	
	}

	
